<!doctype html><html lang=zh-cn data-theme=dark>
<head>
<meta charset=utf-8>
<meta name=viewport content="width=device-width">
<meta name=theme-color content="#222" media="(prefers-color-scheme: dark)">
<meta name=generator content="Hugo 0.92.2">
<link rel="shortcut icon" type=image/x-icon href=/imgs/icons/favicon.ico>
<link rel=icon type=image/x-icon href=/imgs/icons/favicon.ico>
<link rel=icon type=image/png sizes=16x16 href=/imgs/icons/favicon_16x16_next.png>
<link rel=icon type=image/png sizes=32x32 href=/imgs/icons/favicon_32_32_next.png>
<link rel=apple-touch-icon sizes=180x180 href=/imgs/icons/apple_touch_icon_next.png>
<meta itemprop=name content="破解excel工作表密码">
<meta itemprop=description content="破解excel工作表密码">
<meta itemprop=datePublished zgotmplz>
<meta itemprop=dateModified zgotmplz>
<meta itemprop=image content="https://dzmm.gitee.io/imgs/hugo_next_avatar.png">
<meta itemprop=keywords content="excel,破解">
<link type=text/css rel=stylesheet href=https://cdn.staticfile.org/font-awesome/6.1.2/css/all.min.css>
<link type=text/css rel=stylesheet href=https://cdn.staticfile.org/animate.css/3.1.1/animate.min.css>
<link type=text/css rel=stylesheet href=https://cdn.staticfile.org/viewerjs/1.11.0/viewer.min.css>
<link rel=stylesheet href=/css/main.min.659f2a18a0de6aa5054906011a584c8ff887591456aea225eabf98f2cfae91b7.css>
<style type=text/css>.post-footer,.flinks-list-footer hr:after{content:"~ 我可是有底线的哟 ~"}</style>
<script type=text/javascript>(function(){localDB={set:function(b,c,a){if(a===0)return;const d=new Date,e=a*864e5,f={value:c,expiry:d.getTime()+e};localStorage.setItem(b,JSON.stringify(f))},get:function(a){const b=localStorage.getItem(a);if(!b)return void 0;const c=JSON.parse(b),d=new Date;return d.getTime()>c.expiry?(localStorage.removeItem(a),void 0):c.value}},theme={active:function(){const a=localDB.get('theme');if(a==void 0)return;theme.toggle(a),window.matchMedia("(prefers-color-scheme: dark)").addListener(function(a){theme.toggle(a.matches?'dark':'light')})},toggle:function(a){document.documentElement.setAttribute('data-theme',a),localDB.set('theme',a,2);const b=document.querySelector('iframe.giscus-frame');if(b){const c={setConfig:{theme:a}};b.contentWindow.postMessage({giscus:c},'https://giscus.app')}}},theme.active()})(window)</script>
<script class=next-config data-name=page type=application/json>{"comments":false,"isHome":false,"isPage":true,"path":"2019-02-17-excelPWD.html","permalink":"https://dzmm.gitee.io/post/2019-02-17-excelPWD.html","title":"破解excel工作表密码","waline":{"js":[{"alias":"waline","alias_name":"@waline/client","file":"dist/pageview.js","name":"pageview","version":"2.13.0"},{"alias":"waline","alias_name":"@waline/client","file":"dist/comment.js","name":"comment","version":"2.13.0"}]}}</script>
<script type=text/javascript>document.addEventListener('DOMContentLoaded',()=>{var a=document.createElement('script');a.charset="UTF-8",a.src="https://busuanzi.ibruce.info/busuanzi/2.3/busuanzi.pure.mini.js",a.async=!1,a.defer=!0,document.head.appendChild(a),a.onload=function(){NexT.utils.fmtBusuanzi()}})</script>
<title>破解excel工作表密码 - 烂笔头</title>
<noscript>
<link rel=stylesheet href=/css/noscript.css>
</noscript>
</head>
<body itemscope itemtype=http://schema.org/WebPage class=use-motion>
<div class=headband></div>
<main class=main>
<header class=header itemscope itemtype=http://schema.org/WPHeader>
<div class=header-inner>
<div class=site-brand-container>
<div class=site-nav-toggle>
<div class=toggle aria-label role=button>
<span class=toggle-line></span>
<span class=toggle-line></span>
<span class=toggle-line></span>
</div>
</div>
<div class=site-meta>
<a href=/ class=brand rel=start>
<i class=logo-line></i>
<h1 class=site-title>烂笔头</h1>
<i class=logo-line></i>
</a>
<p class=site-subtitle itemprop=description>为 Hugo 打造的主题</p>
</div>
<div class=site-nav-right>
<div class="toggle popup-trigger">
<i class="fa fa-search fa-fw fa-lg"></i>
</div>
</div>
</div>
<nav class=site-nav>
<ul class="main-menu menu">
<li class="menu-item menu-item-home">
<a href=/ class=hvr-icon-pulse rel=section>
<i class="fa fa-home hvr-icon"></i>首页
</a>
</li>
<li class="menu-item menu-item-about">
<a href=/ class=hvr-icon-pulse rel=section>
<i class="fa fa-user hvr-icon"></i>关于
</a>
</li>
<li class="menu-item menu-item-flinks">
<a href=/ class=hvr-icon-pulse rel=section>
<i class="fa fa-thumbs-up hvr-icon"></i>站点示例
</a>
</li>
<li class="menu-item menu-item-archives">
<a href=/ class=hvr-icon-pulse rel=section>
<i class="fa fa-archive hvr-icon"></i>归档
<span class=badge>12</span>
</a>
</li>
<li class="menu-item menu-item-commonweal">
<a href=/404.html class=hvr-icon-pulse rel=section>
<i class="fa fa-heartbeat hvr-icon"></i>公益 404
</a>
</li>
<li class="menu-item menu-item-search">
<a role=button class="popup-trigger hvr-icon-pulse">
<i class="fa fa-search fa-fw hvr-icon"></i>搜索
</a>
</li>
</ul>
</nav>
<div class=search-pop-overlay>
<div class="popup search-popup">
<div class=search-header>
<span class=search-icon>
<i class="fa fa-search"></i>
</span>
<div class=search-input-container>
<input autocomplete=off autocapitalize=off maxlength=80 placeholder=搜索... spellcheck=false type=search class=search-input>
</div>
<span class=popup-btn-close role=button>
<i class="fa fa-times-circle"></i>
</span>
</div>
<div class="search-result-container no-result">
<div class=search-result-icon>
<i class="fa fa-spinner fa-pulse fa-5x"></i>
</div>
</div>
</div>
</div>
</div>
<div class="toggle sidebar-toggle" role=button>
<span class=toggle-line></span>
<span class=toggle-line></span>
<span class=toggle-line></span>
</div>
<aside class=sidebar>
<div class="sidebar-inner sidebar-nav-active sidebar-toc-active">
<ul class=sidebar-nav>
<li class=sidebar-nav-toc>
文章目录
</li>
<li class=sidebar-nav-overview>
站点概览
</li>
</ul>
<div class=sidebar-panel-container>
<div class="post-toc-wrap sidebar-panel">
<div class="post-toc animated"><nav id=TableOfContents>
<ul>
<li>
<ul>
<li><a href=#方法>方法:</a></li>
<li><a href=#内容如下>内容如下：</a></li>
</ul>
</li>
</ul>
</nav></div>
</div>
<div class="site-overview-wrap sidebar-panel">
<div class="site-author site-overview-item animated" itemprop=author itemscope itemtype=http://schema.org/Person>
<img class=site-author-image itemprop=image alt="NexT 主题" src=/imgs/img-lazy-loading.gif data-src=/imgs/hugo_next_avatar.png>
<p class=site-author-name itemprop=name>NexT 主题</p>
<div class=site-description itemprop=description>保持简单的易用性和强大的功能。</div>
</div>
<div class="site-state-wrap site-overview-item animated">
<nav class=site-state>
<div class="site-state-item site-state-posts">
<a href=/archives/>
<span class=site-state-item-count>12</span>
<span class=site-state-item-name>日志</span>
</a>
</div>
<div class="site-state-item site-state-categories">
<a href=/categories/>
<span class=site-state-item-count>8</span>
<span class=site-state-item-name>分类</span>
</a>
</div>
<div class="site-state-item site-state-tags">
<a href=/tags/>
<span class=site-state-item-count>17</span>
<span class=site-state-item-name>标签</span>
</a>
</div>
</nav>
</div>
<div class="links-of-social site-overview-item animated">
<span class=links-of-social-item>
<a href=https://github.com/caoqing title="Github → https://github.com/caoqing" rel=noopener target=_blank>
Github
</a>
</span>
</div>
<div class="cc-license animated" itemprop=license>
<a href=https://creativecommons.org/licenses/by-nc-sa/4.0/deed.zh class=cc-opacity rel=noopener target=_blank title=共享知识>
<img src=/imgs/img-lazy-loading.gif data-src=/imgs/cc/big/by_nc_sa.svg alt=共享知识>
</a>
</div>
<div class="links-of-blogroll site-overview-item animated">
<div class=links-of-blogroll-title>
<i class="fa fa-globe fa-fw"></i>
友情链接
</div>
<ul class=links-of-blogroll-list>
<li class=links-of-blogroll-item>
<a href=https://gitee.com/hugo-next/hugo-theme-next title=https://gitee.com/hugo-next/hugo-theme-next target=_blank>Hugo-NexT</a>
</li>
<li class=links-of-blogroll-item>
<a href=https://lisenhui.cn title=https://lisenhui.cn target=_blank>凡梦星尘空间站</a>
</li>
</ul>
</div>
</div>
</div>
</div>
<div id=siteinfo-card-widget class=sidebar-card-widget>
<div class=item-headline>
<i class="fas fa-chart-line"></i>
<span>网站资讯</span>
</div>
<div class=siteinfo>
<div class=siteinfo-item>
<div class=item-name><i class="fa-solid fa-calendar-check"></i>已运行：</div>
<div class=item-count id=runTimes data-publishdate=2022-06-02T11:52:03+08:00></div>
</div>
<div class=siteinfo-item>
<div class=item-name>
<i class="fas fa fa-user"></i>总访客数：
</div>
<div class=item-count id=busuanzi_value_site_uv><i class="fa fa-sync fa-spin"></i></div>
</div>
<div class=siteinfo-item>
<div class=item-name>
<i class="fas fa fa-eye"></i>页面浏览：
</div>
<div class=item-count id=busuanzi_value_site_pv><i class="fa fa-sync fa-spin"></i></div>
</div>
<div class=siteinfo-item>
<div class=item-name><i class="fa fa-font"></i>总字数：</div>
<div class=item-count id=wordsCount data-count=12210></div>
</div>
<div class=siteinfo-item>
<div class=item-name><i class="fa fa-mug-hot"></i>阅读约：</div>
<div class=item-count id=readTimes data-times=31></div>
</div>
<div class=siteinfo-item>
<div class=item-name><i class="fa fa-clock-rotate-left"></i>最后更新于：</div>
<div class=item-count id=last-push-date data-lastpushdate=2022-12-21T00:00:00+00:00></div>
</div>
</div>
</div>
</aside>
<div class=sidebar-dimmer></div>
</header>
<div class=tool-buttons>
<div id=toggle-theme class=button title=深浅模式切换>
<i class="fas fa-adjust"></i>
</div>
<div class=back-to-top role=button title=返回顶部>
<i class="fa fa-arrow-up"></i>
<span>0%</span>
</div>
</div>
<div class=reading-progress-bar></div>
<a role=button class="book-mark-link book-mark-link-fixed"></a>
<a href=https://github.com/hugo-next rel="noopener external nofollow noreferrer" target=_blank title="Follow me on GitHub" class="exturl github-corner"><svg width="80" height="80" viewBox="0 0 250 250" aria-hidden="true"><path d="M0 0 115 115h15l12 27L250 250V0z"/><path d="M128.3 109C113.8 99.7 119 89.6 119 89.6 122 82.7 120.5 78.6 120.5 78.6 119.2 72 123.4 76.3 123.4 76.3 127.3 80.9 125.5 87.3 125.5 87.3 122.9 97.6 130.6 101.9 134.4 103.2" fill="currentcolor" style="transform-origin:130px 106px" class="octo-arm"/><path d="M115 115C114.9 115.1 118.7 116.5 119.8 115.4l13.9-13.8C136.9 99.2 139.9 98.4 142.2 98.6 133.8 88 127.5 74.4 143.8 58 148.5 53.4 154 51.2 159.7 51 160.3 49.4 163.2 43.6 171.4 40.1 171.4 40.1 176.1 42.5 178.8 56.2 183.1 58.6 187.2 61.8 190.9 65.4 194.5 69 197.7 73.2 200.1 77.6 213.8 80.2 216.3 84.9 216.3 84.9 212.7 93.1 206.9 96 205.4 96.6 205.1 102.4 203 107.8 198.3 112.5 181.9 128.9 168.3 122.5 157.7 114.1 157.9 116.9 156.7 120.9 152.7 124.9L141 136.5C139.8 137.7 141.6 141.9 141.8 141.8z" fill="currentcolor" class="octo-body"/></svg>
</a>
<noscript>
<div class=noscript-warning>Theme NexT works best with JavaScript enabled</div>
</noscript>
<div class="main-inner post posts-expand">
<div class=post-block>
<article itemscope itemtype=http://schema.org/Article class=post-content lang>
<link itemprop=mainEntityOfPage href=https://dzmm.gitee.io/post/2019-02-17-excelPWD.html>
<span hidden itemprop=author itemscope itemtype=http://schema.org/Person>
<meta itemprop=image content="/imgs/hugo_next_avatar.png">
<meta itemprop=name content="NexT 主题">
</span>
<span hidden itemprop=publisher itemscope itemtype=http://schema.org/Organization>
<meta itemprop=name content="NexT 主题">
<meta itemprop=description content="保持简单的易用性和强大的功能。">
</span>
<span hidden itemprop=post itemscope itemtype=http://schema.org/CreativeWork>
<meta itemprop=name content="破解excel工作表密码">
<meta itemprop=description content="破解excel工作表密码">
</span>
<header class=post-header>
<h1 class=post-title itemprop="name headline">
破解excel工作表密码
</h1>
<div class=post-meta-container>
<div class=post-meta-items>
<span class=post-meta-item>
<span class=post-meta-item-icon>
<i class="far fa-calendar"></i>
</span>
<span class=post-meta-item-text title=发表于>
发表于：
</span>
<time title="创建时间：2019-02-21 00:00:00 +0000 UTC" itemprop="dateCreated datePublished" datetime="2019-02-21 00:00:00 +0000 UTC">
2019-02-21
</time>
</span>
<span class=post-meta-item>
<span class=post-meta-item-icon>
<i class="far fa-calendar-check"></i>
</span>
<span class=post-meta-item-text title=更新于>
更新于：
</span>
<time title=修改时间：2022-06-04T19:46:45+08:00 itemprop=dateModified datetime=2022-06-04T19:46:45+08:00>2022-06-04</time>
</span>
<span class=post-meta-item>
<span class=post-meta-item-icon>
<i class="far fa-folder-open"></i>
</span>
<span class=post-meta-item-text title=分类于>
分类于：
</span>
<span itemprop=about itemscope itemtype=http://schema.org/Thing>
<a href=/categories/excel itemprop=url rel=index>
<span itemprop=name>excel</span>
</a>
</span>
</span>
</div>
<div class=post-meta-items>
<span class=post-meta-item title=字数>
<span class=post-meta-item-icon>
<i class="far fa-file-word"></i>
</span>
<span class=post-meta-item-text>字数：</span>
<span>1252</span>
</span>
<span class=post-meta-item title=阅读>
<span class=post-meta-item-icon>
<i class="far fa-clock"></i>
</span>
<span class=post-meta-item-text>阅读：&ap;</span>
<span>3分钟</span>
</span>
<span class=post-meta-item title=浏览>
<span class=post-meta-item-icon>
<i class="far fa-eye"></i>
</span>
<span class=post-meta-item-text>
浏览：
</span>
<span id=busuanzi_value_page_pv data-path=/post/2019-02-17-excelPWD.html>
<i class="fa fa-sync fa-spin"></i>
</span>
</span>
</div>
</div>
</header>
<div class="post-body autonumber" itemprop=articleBody>
<h3 id=方法>方法:
<a class=header-anchor href=#%e6%96%b9%e6%b3%95></a>
</h3><p>1.打开文件。</p>
<p>2.工具—宏—-录制新宏—输入名字如:aa。</p>
<p>3.停止录制(这样得到一个空宏)。</p>
<p>4.工具—宏—-宏,选aa,点编辑按钮。</p>
<p>5.删除窗口中的所有字符(只有几个),替换为下面的内容:(复制吧)。</p>
<p>6.关闭编辑窗口。</p>
<p>7.工具—宏—–宏,选AllInternalPasswords,运行,确定两次,等2分钟,再确定.OK,没有密码了!!</p>
<h3 id=内容如下>内容如下：
<a class=header-anchor href=#%e5%86%85%e5%ae%b9%e5%a6%82%e4%b8%8b></a>
</h3><div class=highlight><pre tabindex=0 style=color:#f8f8f2;background-color:#272822;-moz-tab-size:2;-o-tab-size:2;tab-size:2><code class=language-vb data-lang=vb><span style=color:#66d9ef>Public</span> <span style=color:#66d9ef>Sub</span> <span style=color:#a6e22e>AllInternalPasswords</span>() 
<span style=color:#75715e>&#39; Breaks worksheet and workbook structure passwords. Bob McCormick 
</span><span style=color:#75715e>&#39; probably originator of base code algorithm modified for coverage 
</span><span style=color:#75715e>&#39; of workbook structure / windows passwords and for multiple passwords 
</span><span style=color:#75715e>&#39; 
</span><span style=color:#75715e>&#39; Norman Harker and JE McGimpsey 27-Dec-2002 (Version 1.1) 
</span><span style=color:#75715e>&#39; Modified 2003-Apr-04 by JEM: All msgs to constants, and 
</span><span style=color:#75715e>&#39; eliminate one Exit Sub (Version 1.1.1) 
</span><span style=color:#75715e>&#39; Reveals hashed passwords NOT original passwords 
</span><span style=color:#75715e></span><span style=color:#66d9ef>Const</span> DBLSPACE <span style=color:#f92672>As</span> <span style=color:#66d9ef>String</span> <span style=color:#f92672>=</span> vbNewLine <span style=color:#f92672>&amp;</span> vbNewLine 
<span style=color:#66d9ef>Const</span> AUTHORS <span style=color:#f92672>As</span> <span style=color:#66d9ef>String</span> <span style=color:#f92672>=</span> DBLSPACE <span style=color:#f92672>&amp;</span> vbNewLine <span style=color:#f92672>&amp;</span> _ 
<span style=color:#e6db74>&#34;Adapted from Bob McCormick base code by&#34;</span> <span style=color:#f92672>&amp;</span> _ 
<span style=color:#e6db74>&#34;Norman Harker and JE McGimpsey&#34;</span> 
<span style=color:#66d9ef>Const</span> HEADER <span style=color:#f92672>As</span> <span style=color:#66d9ef>String</span> <span style=color:#f92672>=</span> <span style=color:#e6db74>&#34;AllInternalPasswords User Message&#34;</span> 
<span style=color:#66d9ef>Const</span> VERSION <span style=color:#f92672>As</span> <span style=color:#66d9ef>String</span> <span style=color:#f92672>=</span> DBLSPACE <span style=color:#f92672>&amp;</span> <span style=color:#e6db74>&#34;Version 1.1.1 2003-Apr-04&#34;</span> 
<span style=color:#66d9ef>Const</span> REPBACK <span style=color:#f92672>As</span> <span style=color:#66d9ef>String</span> <span style=color:#f92672>=</span> DBLSPACE <span style=color:#f92672>&amp;</span> <span style=color:#e6db74>&#34;Please report failure &#34;</span> <span style=color:#f92672>&amp;</span> _ 
<span style=color:#e6db74>&#34;to the microsoft.public.excel.programming newsgroup.&#34;</span> 
<span style=color:#66d9ef>Const</span> ALLCLEAR <span style=color:#f92672>As</span> <span style=color:#66d9ef>String</span> <span style=color:#f92672>=</span> DBLSPACE <span style=color:#f92672>&amp;</span> <span style=color:#e6db74>&#34;The workbook should &#34;</span> <span style=color:#f92672>&amp;</span> _ 
<span style=color:#e6db74>&#34;now be free of all password protection, so make sure you:&#34;</span> <span style=color:#f92672>&amp;</span> _ 
DBLSPACE <span style=color:#f92672>&amp;</span> <span style=color:#e6db74>&#34;SAVE IT NOW!&#34;</span> <span style=color:#f92672>&amp;</span> DBLSPACE <span style=color:#f92672>&amp;</span> <span style=color:#e6db74>&#34;and also&#34;</span> <span style=color:#f92672>&amp;</span> _ 
DBLSPACE <span style=color:#f92672>&amp;</span> <span style=color:#e6db74>&#34;BACKUP!, BACKUP!!, BACKUP!!!&#34;</span> <span style=color:#f92672>&amp;</span> _ 
DBLSPACE <span style=color:#f92672>&amp;</span> <span style=color:#e6db74>&#34;Also, remember that the password was &#34;</span> <span style=color:#f92672>&amp;</span> _ 
<span style=color:#e6db74>&#34;put there for a reason. Don&#39;t stuff up crucial formulas &#34;</span> <span style=color:#f92672>&amp;</span> _ 
<span style=color:#e6db74>&#34;or data.&#34;</span> <span style=color:#f92672>&amp;</span> DBLSPACE <span style=color:#f92672>&amp;</span> <span style=color:#e6db74>&#34;Access and use of some data &#34;</span> <span style=color:#f92672>&amp;</span> _ 
<span style=color:#e6db74>&#34;may be an offense. If in doubt, don&#39;t.&#34;</span> 
<span style=color:#66d9ef>Const</span> MSGNOPWORDS1 <span style=color:#f92672>As</span> <span style=color:#66d9ef>String</span> <span style=color:#f92672>=</span> <span style=color:#e6db74>&#34;There were no passwords on &#34;</span> <span style=color:#f92672>&amp;</span> _ 
<span style=color:#e6db74>&#34;sheets, or workbook structure or windows.&#34;</span> <span style=color:#f92672>&amp;</span> AUTHORS <span style=color:#f92672>&amp;</span> VERSION 
<span style=color:#66d9ef>Const</span> MSGNOPWORDS2 <span style=color:#f92672>As</span> <span style=color:#66d9ef>String</span> <span style=color:#f92672>=</span> <span style=color:#e6db74>&#34;There was no protection to &#34;</span> <span style=color:#f92672>&amp;</span> _ 
<span style=color:#e6db74>&#34;workbook structure or windows.&#34;</span> <span style=color:#f92672>&amp;</span> DBLSPACE <span style=color:#f92672>&amp;</span> _ 
<span style=color:#e6db74>&#34;Proceeding to unprotect sheets.&#34;</span> <span style=color:#f92672>&amp;</span> AUTHORS <span style=color:#f92672>&amp;</span> VERSION 
<span style=color:#66d9ef>Const</span> MSGTAKETIME <span style=color:#f92672>As</span> <span style=color:#66d9ef>String</span> <span style=color:#f92672>=</span> <span style=color:#e6db74>&#34;After pressing OK button this &#34;</span> <span style=color:#f92672>&amp;</span> _ 
<span style=color:#e6db74>&#34;will take some time.&#34;</span> <span style=color:#f92672>&amp;</span> DBLSPACE <span style=color:#f92672>&amp;</span> <span style=color:#e6db74>&#34;Amount of time &#34;</span> <span style=color:#f92672>&amp;</span> _ 
<span style=color:#e6db74>&#34;depends on how many different passwords, the &#34;</span> <span style=color:#f92672>&amp;</span> _ 
<span style=color:#e6db74>&#34;passwords, and your computer&#39;s specification.&#34;</span> <span style=color:#f92672>&amp;</span> DBLSPACE <span style=color:#f92672>&amp;</span> _ 
<span style=color:#e6db74>&#34;Just be patient! Make me a coffee!&#34;</span> <span style=color:#f92672>&amp;</span> AUTHORS <span style=color:#f92672>&amp;</span> VERSION 
<span style=color:#66d9ef>Const</span> MSGPWORDFOUND1 <span style=color:#f92672>As</span> <span style=color:#66d9ef>String</span> <span style=color:#f92672>=</span> <span style=color:#e6db74>&#34;You had a Worksheet &#34;</span> <span style=color:#f92672>&amp;</span> _ 
<span style=color:#e6db74>&#34;Structure or Windows Password set.&#34;</span> <span style=color:#f92672>&amp;</span> DBLSPACE <span style=color:#f92672>&amp;</span> _ 
<span style=color:#e6db74>&#34;The password found was: &#34;</span> <span style=color:#f92672>&amp;</span> DBLSPACE <span style=color:#f92672>&amp;</span> <span style=color:#e6db74>&#34;$$&#34;</span> <span style=color:#f92672>&amp;</span> DBLSPACE <span style=color:#f92672>&amp;</span> _ 
<span style=color:#e6db74>&#34;Note it down for potential future use in other workbooks by &#34;</span> <span style=color:#f92672>&amp;</span> _ 
<span style=color:#e6db74>&#34;the same person who set this password.&#34;</span> <span style=color:#f92672>&amp;</span> DBLSPACE <span style=color:#f92672>&amp;</span> _ 
<span style=color:#e6db74>&#34;Now to check and clear other passwords.&#34;</span> <span style=color:#f92672>&amp;</span> AUTHORS <span style=color:#f92672>&amp;</span> VERSION 
<span style=color:#66d9ef>Const</span> MSGPWORDFOUND2 <span style=color:#f92672>As</span> <span style=color:#66d9ef>String</span> <span style=color:#f92672>=</span> <span style=color:#e6db74>&#34;You had a Worksheet &#34;</span> <span style=color:#f92672>&amp;</span> _ 
<span style=color:#e6db74>&#34;password set.&#34;</span> <span style=color:#f92672>&amp;</span> DBLSPACE <span style=color:#f92672>&amp;</span> <span style=color:#e6db74>&#34;The password found was: &#34;</span> <span style=color:#f92672>&amp;</span> _ 
DBLSPACE <span style=color:#f92672>&amp;</span> <span style=color:#e6db74>&#34;$$&#34;</span> <span style=color:#f92672>&amp;</span> DBLSPACE <span style=color:#f92672>&amp;</span> <span style=color:#e6db74>&#34;Note it down for potential &#34;</span> <span style=color:#f92672>&amp;</span> _ 
<span style=color:#e6db74>&#34;future use in other workbooks by same person who &#34;</span> <span style=color:#f92672>&amp;</span> _ 
<span style=color:#e6db74>&#34;set this password.&#34;</span> <span style=color:#f92672>&amp;</span> DBLSPACE <span style=color:#f92672>&amp;</span> <span style=color:#e6db74>&#34;Now to check and clear &#34;</span> <span style=color:#f92672>&amp;</span> _ 
<span style=color:#e6db74>&#34;other passwords.&#34;</span> <span style=color:#f92672>&amp;</span> AUTHORS <span style=color:#f92672>&amp;</span> VERSION 
<span style=color:#66d9ef>Const</span> MSGONLYONE <span style=color:#f92672>As</span> <span style=color:#66d9ef>String</span> <span style=color:#f92672>=</span> <span style=color:#e6db74>&#34;Only structure / windows &#34;</span> <span style=color:#f92672>&amp;</span> _ 
<span style=color:#e6db74>&#34;protected with the password that was just found.&#34;</span> <span style=color:#f92672>&amp;</span> _ 
ALLCLEAR <span style=color:#f92672>&amp;</span> AUTHORS <span style=color:#f92672>&amp;</span> VERSION <span style=color:#f92672>&amp;</span> REPBACK 
<span style=color:#66d9ef>Dim</span> w1 <span style=color:#f92672>As</span> Worksheet, w2 <span style=color:#f92672>As</span> Worksheet 
<span style=color:#66d9ef>Dim</span> i <span style=color:#f92672>As</span> <span style=color:#66d9ef>Integer</span>, j <span style=color:#f92672>As</span> <span style=color:#66d9ef>Integer</span>, k <span style=color:#f92672>As</span> <span style=color:#66d9ef>Integer</span>, l <span style=color:#f92672>As</span> <span style=color:#66d9ef>Integer</span> 
<span style=color:#66d9ef>Dim</span> m <span style=color:#f92672>As</span> <span style=color:#66d9ef>Integer</span>, n <span style=color:#f92672>As</span> <span style=color:#66d9ef>Integer</span>, i1 <span style=color:#f92672>As</span> <span style=color:#66d9ef>Integer</span>, i2 <span style=color:#f92672>As</span> <span style=color:#66d9ef>Integer</span> 
<span style=color:#66d9ef>Dim</span> i3 <span style=color:#f92672>As</span> <span style=color:#66d9ef>Integer</span>, i4 <span style=color:#f92672>As</span> <span style=color:#66d9ef>Integer</span>, i5 <span style=color:#f92672>As</span> <span style=color:#66d9ef>Integer</span>, i6 <span style=color:#f92672>As</span> <span style=color:#66d9ef>Integer</span> 
<span style=color:#66d9ef>Dim</span> PWord1 <span style=color:#f92672>As</span> <span style=color:#66d9ef>String</span> 
<span style=color:#66d9ef>Dim</span> ShTag <span style=color:#f92672>As</span> <span style=color:#66d9ef>Boolean</span>, WinTag <span style=color:#f92672>As</span> <span style=color:#66d9ef>Boolean</span> 

Application.ScreenUpdating <span style=color:#f92672>=</span> <span style=color:#66d9ef>False</span> 
<span style=color:#66d9ef>With</span> ActiveWorkbook 
WinTag <span style=color:#f92672>=</span> .ProtectStructure <span style=color:#f92672>Or</span> .ProtectWindows 
<span style=color:#66d9ef>End</span> <span style=color:#66d9ef>With</span> 
ShTag <span style=color:#f92672>=</span> <span style=color:#66d9ef>False</span> 
<span style=color:#66d9ef>For</span> <span style=color:#66d9ef>Each</span> w1 <span style=color:#f92672>In</span> Worksheets 
ShTag <span style=color:#f92672>=</span> ShTag <span style=color:#f92672>Or</span> w1.ProtectContents 
<span style=color:#66d9ef>Next</span> w1 
<span style=color:#66d9ef>If</span> <span style=color:#66d9ef>Not</span> ShTag <span style=color:#f92672>And</span> <span style=color:#66d9ef>Not</span> WinTag <span style=color:#66d9ef>Then</span> 
MsgBox MSGNOPWORDS1, vbInformation, HEADER 
<span style=color:#66d9ef>Exit</span> <span style=color:#66d9ef>Sub</span> 
<span style=color:#a6e22e>End</span> <span style=color:#66d9ef>If</span> 
MsgBox MSGTAKETIME, vbInformation, HEADER 
<span style=color:#66d9ef>If</span> <span style=color:#66d9ef>Not</span> WinTag <span style=color:#66d9ef>Then</span> 
MsgBox MSGNOPWORDS2, vbInformation, HEADER 
<span style=color:#66d9ef>Else</span> 
<span style=color:#66d9ef>On</span> <span style=color:#66d9ef>Error</span> <span style=color:#66d9ef>Resume</span> <span style=color:#66d9ef>Next</span> 
<span style=color:#66d9ef>Do</span> <span style=color:#75715e>&#39;dummy do loop 
</span><span style=color:#75715e></span><span style=color:#66d9ef>For</span> i <span style=color:#f92672>=</span> 65 <span style=color:#66d9ef>To</span> 66: <span style=color:#66d9ef>For</span> j <span style=color:#f92672>=</span> 65 <span style=color:#66d9ef>To</span> 66: <span style=color:#66d9ef>For</span> k <span style=color:#f92672>=</span> 65 <span style=color:#66d9ef>To</span> 66 
<span style=color:#66d9ef>For</span> l <span style=color:#f92672>=</span> 65 <span style=color:#66d9ef>To</span> 66: <span style=color:#66d9ef>For</span> m <span style=color:#f92672>=</span> 65 <span style=color:#66d9ef>To</span> 66: <span style=color:#66d9ef>For</span> i1 <span style=color:#f92672>=</span> 65 <span style=color:#66d9ef>To</span> 66 
<span style=color:#66d9ef>For</span> i2 <span style=color:#f92672>=</span> 65 <span style=color:#66d9ef>To</span> 66: <span style=color:#66d9ef>For</span> i3 <span style=color:#f92672>=</span> 65 <span style=color:#66d9ef>To</span> 66: <span style=color:#66d9ef>For</span> i4 <span style=color:#f92672>=</span> 65 <span style=color:#66d9ef>To</span> 66 
<span style=color:#66d9ef>For</span> i5 <span style=color:#f92672>=</span> 65 <span style=color:#66d9ef>To</span> 66: <span style=color:#66d9ef>For</span> i6 <span style=color:#f92672>=</span> 65 <span style=color:#66d9ef>To</span> 66: <span style=color:#66d9ef>For</span> n <span style=color:#f92672>=</span> 32 <span style=color:#66d9ef>To</span> 126 
<span style=color:#66d9ef>With</span> ActiveWorkbook 
.Unprotect Chr(i) <span style=color:#f92672>&amp;</span> Chr(j) <span style=color:#f92672>&amp;</span> Chr(k) <span style=color:#f92672>&amp;</span> _ 
Chr(l) <span style=color:#f92672>&amp;</span> Chr(m) <span style=color:#f92672>&amp;</span> Chr(i1) <span style=color:#f92672>&amp;</span> Chr(i2) <span style=color:#f92672>&amp;</span> _ 
Chr(i3) <span style=color:#f92672>&amp;</span> Chr(i4) <span style=color:#f92672>&amp;</span> Chr(i5) <span style=color:#f92672>&amp;</span> Chr(i6) <span style=color:#f92672>&amp;</span> Chr(n) 
<span style=color:#66d9ef>If</span> .ProtectStructure <span style=color:#f92672>=</span> <span style=color:#66d9ef>False</span> <span style=color:#f92672>And</span> _ 
.ProtectWindows <span style=color:#f92672>=</span> <span style=color:#66d9ef>False</span> <span style=color:#66d9ef>Then</span> 
PWord1 <span style=color:#f92672>=</span> Chr(i) <span style=color:#f92672>&amp;</span> Chr(j) <span style=color:#f92672>&amp;</span> Chr(k) <span style=color:#f92672>&amp;</span> Chr(l) <span style=color:#f92672>&amp;</span> _ 
Chr(m) <span style=color:#f92672>&amp;</span> Chr(i1) <span style=color:#f92672>&amp;</span> Chr(i2) <span style=color:#f92672>&amp;</span> Chr(i3) <span style=color:#f92672>&amp;</span> _ 
Chr(i4) <span style=color:#f92672>&amp;</span> Chr(i5) <span style=color:#f92672>&amp;</span> Chr(i6) <span style=color:#f92672>&amp;</span> Chr(n) 
MsgBox Application.Substitute(MSGPWORDFOUND1, _ 
<span style=color:#e6db74>&#34;$$&#34;</span>, PWord1), vbInformation, HEADER 
<span style=color:#66d9ef>Exit</span> <span style=color:#66d9ef>Do</span> <span style=color:#75715e>&#39;Bypass all for...nexts 
</span><span style=color:#75715e></span><span style=color:#66d9ef>End</span> <span style=color:#66d9ef>If</span> 
<span style=color:#66d9ef>End</span> <span style=color:#66d9ef>With</span> 
<span style=color:#66d9ef>Next</span>: <span style=color:#66d9ef>Next</span>: <span style=color:#66d9ef>Next</span>: <span style=color:#66d9ef>Next</span>: <span style=color:#66d9ef>Next</span>: <span style=color:#66d9ef>Next</span> 
<span style=color:#66d9ef>Next</span>: <span style=color:#66d9ef>Next</span>: <span style=color:#66d9ef>Next</span>: <span style=color:#66d9ef>Next</span>: <span style=color:#66d9ef>Next</span>: <span style=color:#66d9ef>Next</span> 
<span style=color:#66d9ef>Loop</span> Until <span style=color:#66d9ef>True</span> 
<span style=color:#66d9ef>On</span> <span style=color:#66d9ef>Error</span> <span style=color:#66d9ef>GoTo</span> 0 
<span style=color:#66d9ef>End</span> <span style=color:#66d9ef>If</span> 
<span style=color:#66d9ef>If</span> WinTag <span style=color:#f92672>And</span> <span style=color:#66d9ef>Not</span> ShTag <span style=color:#66d9ef>Then</span> 
MsgBox MSGONLYONE, vbInformation, HEADER 
<span style=color:#66d9ef>Exit</span> <span style=color:#66d9ef>Sub</span> 
<span style=color:#a6e22e>End</span> <span style=color:#66d9ef>If</span> 
<span style=color:#66d9ef>On</span> <span style=color:#66d9ef>Error</span> <span style=color:#66d9ef>Resume</span> <span style=color:#66d9ef>Next</span> 
<span style=color:#66d9ef>For</span> <span style=color:#66d9ef>Each</span> w1 <span style=color:#f92672>In</span> Worksheets 
<span style=color:#75715e>&#39;Attempt clearance with PWord1 
</span><span style=color:#75715e></span>w1.Unprotect PWord1 
<span style=color:#66d9ef>Next</span> w1 
<span style=color:#66d9ef>On</span> <span style=color:#66d9ef>Error</span> <span style=color:#66d9ef>GoTo</span> 0 
ShTag <span style=color:#f92672>=</span> <span style=color:#66d9ef>False</span> 
<span style=color:#66d9ef>For</span> <span style=color:#66d9ef>Each</span> w1 <span style=color:#f92672>In</span> Worksheets 
<span style=color:#75715e>&#39;Checks for all clear ShTag triggered to 1 if not. 
</span><span style=color:#75715e></span>ShTag <span style=color:#f92672>=</span> ShTag <span style=color:#f92672>Or</span> w1.ProtectContents 
<span style=color:#66d9ef>Next</span> w1 
<span style=color:#66d9ef>If</span> ShTag <span style=color:#66d9ef>Then</span> 
<span style=color:#66d9ef>For</span> <span style=color:#66d9ef>Each</span> w1 <span style=color:#f92672>In</span> Worksheets 
<span style=color:#66d9ef>With</span> w1 
<span style=color:#66d9ef>If</span> .ProtectContents <span style=color:#66d9ef>Then</span> 
<span style=color:#66d9ef>On</span> <span style=color:#66d9ef>Error</span> <span style=color:#66d9ef>Resume</span> <span style=color:#66d9ef>Next</span> 
<span style=color:#66d9ef>Do</span> <span style=color:#75715e>&#39;Dummy do loop 
</span><span style=color:#75715e></span><span style=color:#66d9ef>For</span> i <span style=color:#f92672>=</span> 65 <span style=color:#66d9ef>To</span> 66: <span style=color:#66d9ef>For</span> j <span style=color:#f92672>=</span> 65 <span style=color:#66d9ef>To</span> 66: <span style=color:#66d9ef>For</span> k <span style=color:#f92672>=</span> 65 <span style=color:#66d9ef>To</span> 66 
<span style=color:#66d9ef>For</span> l <span style=color:#f92672>=</span> 65 <span style=color:#66d9ef>To</span> 66: <span style=color:#66d9ef>For</span> m <span style=color:#f92672>=</span> 65 <span style=color:#66d9ef>To</span> 66: <span style=color:#66d9ef>For</span> i1 <span style=color:#f92672>=</span> 65 <span style=color:#66d9ef>To</span> 66 
<span style=color:#66d9ef>For</span> i2 <span style=color:#f92672>=</span> 65 <span style=color:#66d9ef>To</span> 66: <span style=color:#66d9ef>For</span> i3 <span style=color:#f92672>=</span> 65 <span style=color:#66d9ef>To</span> 66: <span style=color:#66d9ef>For</span> i4 <span style=color:#f92672>=</span> 65 <span style=color:#66d9ef>To</span> 66 
<span style=color:#66d9ef>For</span> i5 <span style=color:#f92672>=</span> 65 <span style=color:#66d9ef>To</span> 66: <span style=color:#66d9ef>For</span> i6 <span style=color:#f92672>=</span> 65 <span style=color:#66d9ef>To</span> 66: <span style=color:#66d9ef>For</span> n <span style=color:#f92672>=</span> 32 <span style=color:#66d9ef>To</span> 126 
.Unprotect Chr(i) <span style=color:#f92672>&amp;</span> Chr(j) <span style=color:#f92672>&amp;</span> Chr(k) <span style=color:#f92672>&amp;</span> _ 
Chr(l) <span style=color:#f92672>&amp;</span> Chr(m) <span style=color:#f92672>&amp;</span> Chr(i1) <span style=color:#f92672>&amp;</span> Chr(i2) <span style=color:#f92672>&amp;</span> Chr(i3) <span style=color:#f92672>&amp;</span> _ 
Chr(i4) <span style=color:#f92672>&amp;</span> Chr(i5) <span style=color:#f92672>&amp;</span> Chr(i6) <span style=color:#f92672>&amp;</span> Chr(n) 
<span style=color:#66d9ef>If</span> <span style=color:#66d9ef>Not</span> .ProtectContents <span style=color:#66d9ef>Then</span> 
PWord1 <span style=color:#f92672>=</span> Chr(i) <span style=color:#f92672>&amp;</span> Chr(j) <span style=color:#f92672>&amp;</span> Chr(k) <span style=color:#f92672>&amp;</span> Chr(l) <span style=color:#f92672>&amp;</span> _ 
Chr(m) <span style=color:#f92672>&amp;</span> Chr(i1) <span style=color:#f92672>&amp;</span> Chr(i2) <span style=color:#f92672>&amp;</span> Chr(i3) <span style=color:#f92672>&amp;</span> _ 
Chr(i4) <span style=color:#f92672>&amp;</span> Chr(i5) <span style=color:#f92672>&amp;</span> Chr(i6) <span style=color:#f92672>&amp;</span> Chr(n) 
MsgBox Application.Substitute(MSGPWORDFOUND2, _ 
<span style=color:#e6db74>&#34;$$&#34;</span>, PWord1), vbInformation, HEADER
<span style=color:#75715e>&#39;leverage finding Pword by trying on other sheets
</span><span style=color:#75715e></span><span style=color:#66d9ef>For</span> <span style=color:#66d9ef>Each</span> w2 <span style=color:#f92672>In</span> Worksheets
w2.Unprotect PWord1
<span style=color:#66d9ef>Next</span> w2
<span style=color:#66d9ef>Exit</span> <span style=color:#66d9ef>Do</span> <span style=color:#75715e>&#39;Bypass all for...nexts
</span><span style=color:#75715e></span><span style=color:#66d9ef>End</span> <span style=color:#66d9ef>If</span>
<span style=color:#66d9ef>Next</span>: <span style=color:#66d9ef>Next</span>: <span style=color:#66d9ef>Next</span>: <span style=color:#66d9ef>Next</span>: <span style=color:#66d9ef>Next</span>: <span style=color:#66d9ef>Next</span>
<span style=color:#66d9ef>Next</span>: <span style=color:#66d9ef>Next</span>: <span style=color:#66d9ef>Next</span>: <span style=color:#66d9ef>Next</span>: <span style=color:#66d9ef>Next</span>: <span style=color:#66d9ef>Next</span>
<span style=color:#66d9ef>Loop</span> Until <span style=color:#66d9ef>True</span>
<span style=color:#66d9ef>On</span> <span style=color:#66d9ef>Error</span> <span style=color:#66d9ef>GoTo</span> 0
<span style=color:#66d9ef>End</span> <span style=color:#66d9ef>If</span>
<span style=color:#66d9ef>End</span> <span style=color:#66d9ef>With</span>
<span style=color:#66d9ef>Next</span> w1
<span style=color:#66d9ef>End</span> <span style=color:#66d9ef>If</span>
MsgBox ALLCLEAR <span style=color:#f92672>&amp;</span> AUTHORS <span style=color:#f92672>&amp;</span> VERSION <span style=color:#f92672>&amp;</span> REPBACK, vbInformation, HEADER
<span style=color:#66d9ef>End</span> <span style=color:#66d9ef>Sub</span>
</code></pre></div>
</div>
<footer class=post-footer>
<div class=post-tags>
<a href=/tags/excel>
excel
</a>
<a href=/tags/%e7%a0%b4%e8%a7%a3>
破解
</a>
</div>
<div class=addthis_inline_share_toolbox style=text-align:center></div>
<hr>
<div class=post-nav>
<div class="post-nav-next post-nav-item">
<a href=/post/2019-02-26-html-val.html rel=next title=常用html元素的取值和赋值方法总结>
<i class="fa fa-chevron-left"></i> 常用html元素的取值和赋值方法总结
</a>
</div>
<div class="post-nav-prev post-nav-item">
<a href=/post/2019-02-17-excelsheet.html rel=prev title=转载:EXCEL技巧─利用函数获取工作表名>
转载:EXCEL技巧─利用函数获取工作表名
<i class="fa fa-chevron-right"></i>
</a>
</div>
</div>
</footer>
</article>
</div>
</div>
</main>
<footer class=footer>
<div class=footer-inner>
<div class=copyright>
&copy;
<span itemprop=copyrightYear>
2010 - 2023
</span>
<span class=with-love>
<i class="fa fa-heart"></i>
</span>
<span class=author itemprop=copyrightHolder>NexT 主题</span>
</div>
<div class=powered-by>
由 <a href=https://gohugo.io title=0.92.2 target=_blank>Hugo</a> & <a href=https://github.com/hugo-next/hugo-theme-next title=4.5.3 target=_blank>Hugo NexT.Gemini</a> 强力驱动
</div>
</div>
</footer>
<script type=text/javascript src=https://cdn.staticfile.org/animejs/3.2.1/anime.min.js defer></script>
<script type=text/javascript src=https://cdn.staticfile.org/viewerjs/1.11.0/viewer.min.js defer></script>
<script class=next-config data-name=main type=application/json>{"bookmark":{"color":"#222","enable":true,"save":"manual"},"copybtn":true,"darkmode":true,"giscus":{"cfg":{"category":"Comments","categoryid":null,"emit":false,"inputposition":"top","mapping":"title","reactions":false,"repo":"username/repo-name","repoid":null,"theme":"preferred_color_scheme"},"js":"https://giscus.app/client.js"},"hostname":"https://dzmm.gitee.io","i18n":{"ds_day":" 天前","ds_days":" 天 ","ds_hour":" 小时前","ds_hours":" 小时 ","ds_just":"刚刚","ds_min":" 分钟前","ds_mins":" 分钟","ds_month":" 个月前","ds_years":" 年 ","empty":"没有找到任何搜索结果：${query}","hits":"找到 ${hits} 个搜索结果","hits_time":"找到 ${hits} 个搜索结果（用时 ${time} 毫秒）","placeholder":"搜索..."},"lang":"zh-CN","lazyload":false,"localSearch":{"enable":true,"limit":1e3,"path":"/searchindexes.xml","preload":false,"topnperarticle":-1,"trigger":"auto","unescape":false},"motion":{"async":true,"enable":true,"transition":{"collheader":"fadeInLeft","postblock":"fadeIn","postbody":"fadeInDown","postheader":"fadeInDown","sidebar":"fadeInUp"}},"postmeta":{"comments":{"enable":false,"plugin":"waline"},"views":{"enable":true,"plugin":"busuanzi"}},"root":"/","scheme":"Gemini","sidebar":{"display":"post","offset":12,"padding":18,"position":"left","width":256},"vendor":{"plugins":"qiniu","router":"https://cdn.staticfile.org"},"version":"4.5.3","waline":{"cfg":{"emoji":false,"imguploader":false,"placeholder":"请文明发言哟 ヾ(≧▽≦*)o","reaction":true,"reactiontext":["点赞","踩一下","得意","不屑","尴尬","睡觉"],"reactiontitle":"你认为这篇文章怎么样？","requiredmeta":["nick","mail"],"serverurl":null,"sofa":"快来发表你的意见吧 (≧∀≦)ゞ","wordlimit":200},"css":{"alias":"waline","file":"dist/waline.css","name":"@waline/client","version":"2.13.0"},"js":{"alias":"waline","file":"dist/waline.js","name":"@waline/client","version":"2.13.0"}}}</script>
<script type=text/javascript src=/js/main.min.da1a84618d05ef38d3aaca7a8e93f6433f9bb147d8ffcc3a840de8a03dc5ff9f.js defer></script>
</body>
</html>